{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Datos","Asistencia","Calificaciones","Reporte"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Datos","index":0,"n_rows":141,"n_cols":11,"rows_kept":141,"cut":false,"hidden":false,"merged":[[4,2,4,4],[3,5,3,6],[3,7,3,8],[0,1,0,8],[1,2,1,4],[1,5,1,6],[1,7,1,8],[2,2,2,4],[2,5,2,6],[2,7,2,8],[3,2,3,4]]}
[null,"Instrucciones:\n- Llene en este cuadro los datos de la asignatura. El nombre de la asignatura y el ciclo se eligen de una lista. \n- Estos datos se transferirán de manera automática, oportuna e inmediata a las otras dos hojas. \n- En la hoja de ASISTENCIA capture los nombres de los estudiantes, y éstos se pasarán a la hoja de CALIFICACIONES. \n- Se sugiere imprimir la hoja de ASISTENCIA para pasar lista durante el curso. Si así lo desea, también puede usarla para pasar lista, capturando 0 para falta, y 1 para asistencia.\n- La hoja de CALIFICACIONES puede ser llenada e impresa con cada evaluación.\n- En todas las hojas, las celdas verdes indican espacios que deben ser llenados."]
[null,"Nombre de la asignatura",null,null,null,"Sección",null,null,null,{"$f":"COUNTBLANK(C3:E5)","v":9}]
[null,"Nombres del profesor",null,null,null,"Semestre",null,null,null,{"$f":"COUNTBLANK(H2:I3)","v":4},{"$f":"SUBSTITUTE(C3,\" \",\"\")","v":""}]
[null,"Apellidos del profesor",null,null,null,"Ciclo",null,null,null,{"$f":"COUNTBLANK(H4)","v":1},{"$f":"SUBSTITUTE(C4,\" \",\"\")","v":""}]
[null,"Horario",null,null,null,null,null,null,null,{"$f":"SUM(J2:J4)","v":14}]
[null,"Academia a la que pertenece",{"$f":"VLOOKUP(C2,B9:E203,2,FALSE)","v":{"$error":"#N/A"}},"Asig",{"$f":"VLOOKUP(C2,B9:E203,4,FALSE)","v":{"$error":"#N/A"}},null,"Acad",{"$f":"VLOOKUP(C2,B9:E203,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Clave completa",{"$f":"IF(J5>8,\"\",CONCATENATE(H4,\"_\",H6,\"_\",E6,\"_\",H2,\"_\",E7,\"_\",F7))","v":""},"Nombres",{"$f":"UPPER(MID(K4,1,4))","v":""},{"$f":"UPPER(MID(K3,1,4))","v":""}]
[null,"Asignatura","Academia","Clave Academia","Clave Asignatura",null,null,null,null,null,"Ciclos"]
[null,"Administración de sueldos y salarios","Psicología laboral","LAB","ASYS",null,null,null,null,null,"25-25"]
[null,"Análisis de información y datos cualitativos","Metodología","MET","AIDC",null,null,null,null,null,"25-26"]
[null,"Asesoría y trabajo con grupos","Formación para la intervención","FIN","ATG",null,null,null,null,null,"26-26"]
[null,"Bases biológicas del comportamiento","Psicología biológica y neuropsicología","BIO","BBC",null,null,null,null,null,"26-27"]
[null,"Bases evolutivas de la conducta y la cognición","Psicología biológica y neuropsicología","BIO","BECC",null,null,null,null,null,"27-27"]
[null,"Clínica de la infancia y la adolescencia","Psicoanálisis","PSA","CLIAD",null,null,null,null,null,"27-28"]
[null,"Clínica de las neurosis","Psicoanálisis","PSA","CLN",null,null,null,null,null,"28-28"]
[null,"Clínica de las perversiones y las psicosis","Psicoanálisis","PSA","CLPP",null,null,null,null,null,"28-29"]
[null,"Desarrollo del potencial humano","Humanista","HUM","DPH",null,null,null,null,null,"29-29"]
[null,"Desarrollo organizacional","Psicología laboral","LAB","DORG",null,null,null,null,null,"29-30"]
[null,"Diagnóstico familiar: estudio de casos","Sistémico familiar","SIS","DXF",null,null,null,null,null,"30-30"]
[null,"Diagnósticos psicosociales","Psicología social","SOC","DXPS",null,null,null,null,null,"30-31"]
[null,"Didáctica y organización de ambientes de aprendizaje","Psicología educativa","EDU","DOAA",null,null,null,null,null,"31-31"]
[null,"Diseño de programas de intervención","Formación para la intervención","FIN","DPI",null,null,null,null,null,"31-32"]
[null,"Diseños mixtos de investigación","Formación transversal","TRA","DMI",null,null,null,null,null,"32-32"]
[null,"Elaboración de artículos científicos y de divulgación","Formación transversal","TRA","EAC"]
[null,"Emociones y sentimientos desde la psicología humanista","Humanista","HUM","ESPH"]
[null,"Entrevista psicológica","Psicodiagnóstico","PDX","ENTPSI"]
[null,"Epistemología de la Psicología","Fundamentación filosófica","FFI","EPPS"]
[null,"Epistemologías decoloniales y feministas","Formación transversal","TRA","EDCF"]
[null,"Escritura de textos académicos en psicología","Formación transversal","TRA","ETAP"]
[null,"Escuela inglesa de psicoanálisis","Psicoanálisis","PSA","EIPA"]
[null,"Estadística descriptiva","Metodología","MET","ESDE"]
[null,"Estadística inferencial","Metodología","MET","ESIN"]
[null,"Estrategias básicas para el trabajo del psicólogo escolar","Psicología educativa","EDU","EBTPE"]
[null,"Estrategias básicas para el trabajo en educación especial","Psicología educativa","EDU","EBTEE"]
[null,"Estrategias de orientación familiar","Sistémico familiar","SIS","EOF"]
[null,"Estrategias y materiales de apoyo para las actividades de orientación educativa","Psicología educativa","EDU","EMAAO"]
[null,"Estudio de la familia desde la perspectiva sistémica","Sistémico familiar","SIS","EFPS"]
[null,"Estudio experimental de procesos cognitivos","Cognitivo conductual","COG","EEPC"]
[null,"Estudio experimental de procesos conductuales y de orden superior","Cognitivo conductual","COG","EEPCO"]
[null,"Estudio sistémico de la familia multiproblemática","Sistémico familiar","SIS","ESFMP"]
[null,"Estudios de género","Psicología social","SOC","EG"]
[null,"Estudios psicoanalíticos de la criminalidad","Psicoanálisis","PSA","EPAC"]
[null,"Ética y psicología","Fundamentación filosófica","FFI","EYP"]
[null,"Evaluación clínica de la conducta y la cognición","Cognitivo conductual","COG","ECCC"]
[null,"Evaluación educativa","Psicología educativa","EDU","EVED"]
[null,"Evaluación neuropsicológica","Psicología biológica y neuropsicología","BIO","EVNP"]
[null,"Evaluación psicogerontológica y modelos de intervención en la vejez","Formación transversal","TRA","EPGMI"]
[null,"Evaluación psicológica en las organizaciones","Psicología laboral","LAB","EPO"]
[null,"Evaluación y diseño de intervenciones educativas en la primera infancia","Psicología educativa","EDU","EDIE"]
[null,"Familia, evaluación e intervención","Sistémico familiar","SIS","FEI"]
[null,"Fundamentos del enfoque humanista","Humanista","HUM","FEH"]
[null,"Fundamentos del psicoanálisis","Psicoanálisis","PSA","FPA"]
[null,"Fundamentos filosóficos de la psicología","Fundamentación filosófica","FFI","FFP"]
[null,"Gestión del talento humano","Psicología laboral","LAB","GTH"]
[null,"Habilidades lectoras en inglés","Formación transversal","TRA","HLI"]
[null,"Instrumentos de evaluación y diagnóstico","Formación transversal","TRA","IEDX"]
[null,"Integración y difusión de la profesionalización","Formación para la intervención","FIN","IDP"]
[null,"Intervención en parejas y familias en crisis","Sistémico familiar","SIS","IPFC"]
[null,"Intervención en prácticas de crianza","Formación transversal","TRA","IPC"]
[null,"Intervención en psicología social","Psicología social","SOC","IPS"]
[null,"Intervención en psicoterapia humanista","Humanista","HUM","IPH"]
[null,"Intervención en situaciones sociales emergentes","Psicología social","SOC","ISSE"]
[null,"Intervención grupal en psicoanálisis","Psicoanálisis","PSA","IGPA"]
[null,"Intervención psicopedagógica con niños y adolescentes","Psicología educativa","EDU","IPPNA"]
[null,"Intervenciones cognitivas y conductuales en contextos institucionales","Cognitivo conductual","COG","ICCCI"]
[null,"Intervenciones en análisis de la conducta","Cognitivo conductual","COG","IAC"]
[null,"Introducción a la epistemología","Fundamentación filosófica","FFI","EPIS"]
[null,"Introducción a la psicología organizacional y del trabajo","Psicología laboral","LAB","IPOT"]
[null,"Introducción a las teorías conductual y cognitivo conductual","Cognitivo conductual","COG","ITCCC"]
[null,"Laboratorio de bases biológicas del comportamiento","Psicología biológica y neuropsicología","BIO","LABBB"]
[null,"Laboratorio de psicobiología","Psicología biológica y neuropsicología","BIO","LABPB"]
[null,"Logoterapia","Humanista","HUM","LOGOT"]
[null,"Medicina conductual","Cognitivo conductual","COG","MEDC"]
[null,"Método psicoanalítico","Psicoanálisis","PSA","MPA"]
[null,"Metodología cualitativa","Metodología","MET","MCUAL"]
[null,"Metodología cuantitativa","Metodología","MET","MCUAN"]
[null,"Modelos de intervención en crisis","Formación para la intervención","FIN","MIC"]
[null,"Neuropsicología clínica","Psicología biológica y neuropsicología","BIO","NPC"]
[null,"Neuropsicopatología","Psicología biológica y neuropsicología","BIO","NPP"]
[null,"Organizaciones y calidad de vida","Psicología laboral","LAB","OCV"]
[null,"Orientación educativa","Psicología educativa","EDU","OE"]
[null,"Permanencia y desarrollo del talento humano","Psicología laboral","LAB","PDTH"]
[null,"Perspectivas psicológicas de la migración","Formación transversal","TRA","PPM"]
[null,"Procesos de comunicación","Sistémico familiar","SIS","COM"]
[null,"Procesos de desarrollo del lenguaje humano","Psicología del desarrollo","PSD","PDLH"]
[null,"Proyecto de investigación en psicología (biológica y neuropsicología)","Psicología biológica y neuropsicología","BIO","PRYBN"]
[null,"Proyecto de investigación en psicología (cognitivo-conductual)","Cognitivo conductual","COG","PRYCC"]
[null,"Proyecto de investigación en psicología (educativa)","Psicología educativa","EDU","PRYED"]
[null,"Proyecto de investigación en psicología (humanista)","Humanista","HUM","PRYHU"]
[null,"Proyecto de investigación en psicología (laboral)","Psicología laboral","LAB","PRYLB"]
[null,"Proyecto de investigación en psicología (psicoanálisis)","Psicoanálisis","PSA","PRYPS"]
[null,"Proyecto de investigación en psicología (sistémico-familiar)","Sistémico familiar","SIS","PRYSF"]
[null,"Proyecto de investigación en psicología (social)","Psicología social","SOC","PRYSC"]
[null,"Psicoanálisis de las organizaciones e instituciones","Psicoanálisis","PSA","PAOI"]
[null,"Psicobiología","Psicología biológica y neuropsicología","BIO","PSBIO"]
[null,"Psicodiagnóstico en adolescentes y adultos","Psicodiagnóstico","PDX","PDAA"]
[null,"Psicodiagnóstico en niños","Psicodiagnóstico","PDX","PDN"]
[null,"Psicofarmacología","Psicología biológica y neuropsicología","BIO","PSIFAR"]
[null,"Psicología comunitaria y ambiental","Psicología social","SOC","PCA"]
[null,"Psicología de la adolescencia","Psicología del desarrollo","PSD","PAD"]
[null,"Psicología de la adultez","Psicología del desarrollo","PSD","PSA"]
[null,"Psicología de la educación","Psicología educativa","EDU","PE"]
[null,"Psicología de la mercadotecnia y el emprendimiento","Psicología laboral","LAB","PME"]
[null,"Psicología de la niñez","Psicología del desarrollo","PSD","PN"]
[null,"Psicología de la salud","Formación para la intervención","FIN","PSS"]
[null,"Psicología de la vejez","Psicología del desarrollo","PSD","PSV"]
[null,"Psicología de las adicciones","Psicología biológica y neuropsicología","BIO","PSAD"]
[null,"Psicología del arte","Formación transversal","TRA","PSAR"]
[null,"Psicología del deporte","Formación transversal","TRA","PSDE"]
[null,"Psicología forense","Formación transversal","TRA","PSJF"]
[null,"Psicología social","Psicología social","SOC","PS"]
[null,"Psicología social crítica","Psicología social","SOC","PSC"]
[null,"Psicología social de la vejez","Psicología social","SOC","PSV"]
[null,"Psicología social del trabajo","Psicología social","SOC","PST"]
[null,"Psicometría","Metodología","MET","PM"]
[null,"Psicopatología de la infancia y la adolescencia","Psicodiagnóstico","PSD","PPIA"]
[null,"Psicopatología descriptiva","Psicodiagnóstico","PSD","PPD"]
[null,"Psicoterapia Gestalt","Humanista","HUM","PTG"]
[null,"Rehabilitación cognitiva","Psicología biológica y neuropsicología","BIO","RHC"]
[null,"Relaciones laborales","Psicología laboral","LAB","RL"]
[null,"Resiliencia familiar y psicología positiva","Sistémico familiar","SIS","RFPP"]
[null,"Salud y seguridad en el trabajo","Psicología laboral","LAB","SYST"]
[null,"Seminario vivencial","Humanista","HUM","SV"]
[null,"Sexología","Formación transversal","TRA","SX"]
[null,"Significaciones colectivas y procesos psicosociales","Psicología social","SOC","SCPP"]
[null,"Sociedad y cultura","Psicología social","SOC","SC"]
[null,"Taller de elaboración de artículos sobre familia","Sistémico familiar","SIS","TEAF"]
[null,"Técnicas cognitivo conductuales para la intervención clínica","Cognitivo conductual","COG","TCCIC"]
[null,"Técnicas psicoterapéuticas humanistas","Humanista","HUM","TPTH"]
[null,"Temas selectos de neuropsicología","Psicología biológica y neuropsicología","BIO","TSNP"]
[null,"Temas selectos de psicoanálisis","Psicoanálisis","PSA","TSPA"]
[null,"Temas selectos de psicología cognitivo conductual","Cognitivo conductual","COG","TSPCC"]
[null,"Temas selectos de psicología de la educación","Psicología educativa","EDU","TSPE"]
[null,"Temas selectos de psicología humanista","Humanista","HUM","TSPH"]
[null,"Temas selectos de psicología laboral","Psicología laboral","LAB","TSPL"]
[null,"Temas selectos de psicología sistémico-familiar","Sistémico familiar","SIS","TSPSF"]
[null,"Temas selectos de psicología social","Psicología social","SOC","TSPS"]
[null,"Teoría del sujeto en Jacques Lacan","Psicoanálisis","PSA","TSJL"]
[null,"Terapias cognitivo-conductuales de 3a generación","Cognitivo conductual","COG","TCC3G"]
[null,"Trabajo con grupos con enfoque humanista","Humanista","HUM","TGEH"]
[null,"Vulnerabilidades en el curso de vida","Formación transversal","TRA","VCV"]

{"sheet":"Asistencia","index":1,"n_rows":74,"n_cols":38,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,1,2,3],[0,1,0,3],[3,37,3,38],[1,18,1,38],[2,18,2,38],[0,14,0,38]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Datos!$C2<>\"\",(CONCATENATE(Datos!$C2,\", \",Datos!$H2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Datos!$C3<>\"\",(CONCATENATE(Datos!C3,\" \",Datos!C4)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Datos!$C5<>\"\",Datos!$C5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M4:N4)","v":18},{"$f":"COUNTBLANK(Datos!C2:E5)","v":12},{"$f":"COUNTBLANK(Datos!H2:I4)","v":6},null,null,null,null,null,null,"Estudiantes registrados:",{"$f":"COUNTA(B7:B74)","v":0},{"$f":"68-COUNTIF(A$7:A$74,\"\")","v":68},null,null,null,null,null,"Grupo o sección:",{"$f":"IF(Datos!H2<>\"\",Datos!H2,\"\")","v":""},null,null,"Semestre:",{"$f":"IF(Datos!H3<>\"\",Datos!H3,\"\")","v":""},null,null,"Ciclo escolar:",{"$f":"IF(Datos!$H$4<>\"\",Datos!$H$4,\"\")","v":""}]
[]
["No","Apellidos","Nombres","Nombres iguales",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,"TOTAL"]
[1,null,null,{"$f":"IF(C7<>\"\",COUNTIF(C$7:C$74,C7),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISERROR(SUM(E7:AH7)),SUM(E7:AH7)=0),\"\",SUM(E7:AH7))","v":""}]
[2,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISERROR(SUM(E8:AH8)),SUM(E8:AH8)=0),\"\",SUM(E8:AH8))","v":""}]
[3,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[8,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[9,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[12,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[16,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[17,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[18,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[19,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[20,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[21,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[22,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[23,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[24,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[25,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[26,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[27,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[28,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[29,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[30,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[31,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[32,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[33,null,null,{"$f":"IF(C39<>\"\",COUNTIF(C$7:C$74,C39),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[34,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[35,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[36,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[37,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[38,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[39,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[40,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[41,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[42,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[43,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[44,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[45,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[46,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[47,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[48,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[49,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[50,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[51,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[52,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[53,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[54,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[55,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[56,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[57,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[58,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[59,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[60,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[61,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[62,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[63,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[64,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[65,null,null,{"$f":"IF(C71<>\"\",COUNTIF(C$7:C$74,C71),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[66,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISERROR(SUM(E72:AH72)),SUM(E72:AH72)=0),\"\",SUM(E72:AH72))","v":""}]
[67,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[68,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Calificaciones","index":2,"n_rows":80,"n_cols":17,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,5,1,6],[2,8,2,15],[1,8,1,15],[0,5,0,7],[0,8,0,15],[3,3,3,4],[5,3,5,4],[2,5,2,6],[3,5,3,6],[4,5,4,6],[0,2,2,2],[7,14,7,15],[3,2,4,2],[5,1,7,2],[7,9,7,13],[6,3,6,4],[4,3,4,4],[3,8,3,15],[4,8,4,15],[5,8,5,15],[0,3,0,4],[1,3,1,4],[2,3,2,4],[6,5,6,6],[6,8,6,15],[5,5,5,6]]}
[null,null,"Reporte de calificaciones","Profesor",null,{"$f":"IF(Datos!C3<>\"\",(CONCATENATE(Datos!C3,\" \",Datos!C4)),\"\")","v":""},null,null,"Rubro",null,null,null,null,null,null,null,"Porcentaje"]
[null,null,null,"Asignatura",null,{"$f":"IF(Datos!C2<>\"\",Datos!C2,\"\")","v":""},null,1]
[null,null,null,"Semestre",null,{"$f":"IF(Datos!H3<>\"\",Datos!H3,\"\")","v":""},null,2]
[null,null,{"$f":"CONCATENATE(\"Ciclo \",F5)","v":"Ciclo "},"Sección",null,{"$f":"IF(Datos!H2<>\"\",Datos!H2,\"\")","v":""},null,3]
[null,null,null,"Ciclo Escolar",null,{"$f":"IF(Datos!H4<>\"\",Datos!H4,\"\")","v":""},null,4]
[null,{"$f":"CONCATENATE(F2,\" \",F4)","v":" "},null,"Clases Impartidas",null,null,null,5]
[null,null,null,null,null,null,null,6]
[null,null,null,"Método para calcular la calificación final:",null,null,null,null,null,"1)Promediar a y b",null,null,null,null,"Total",null,{"$f":"SUM(Q2:Q7)","v":0}]
[null,null,null,{"$f":"CONCATENATE(\"\\\",Datos!C7,\"_CUANTI.pdf\")","v":"\\_CUANTI.pdf"},null,null,null,null,null,{"$f":"MID(J8,1,1)","v":"1"}]
["No","Apellidos","Nombres","  Asistencias"," % Asistencia",{"$f":"IF(I2<>\"\",I2,\"\")","v":""},{"$f":"IF(I3<>\"\",I3,\"\")","v":""},{"$f":"IF(I4<>\"\",I4,\"\")","v":""},{"$f":"IF(I5<>\"\",I5,\"\")","v":""},{"$f":"IF(I6<>\"\",I6,\"\")","v":""},{"$f":"IF(I7<>\"\",I7,\"\")","v":""},"Promedio en el cuso (a)","Examen final (b)","Calificación Final","Extraordinario","Regularización","Por asistencia tiene derecho"]
[1,{"$f":"IF(Asistencia!B7<>\"\",Asistencia!B7,\"\")","v":""},{"$f":"IF(Asistencia!C7<>\"\",Asistencia!C7,\"\")","v":""},null,{"$f":"IF(D11<>\"\",(D11/$F$6),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B11<>\"\",COUNTBLANK(F11:K11)<6),((F11*$Q$2)+(G11*$Q$3)+(H11*$Q$4)+(I11*$Q$5)+(J11*$Q$6)+(K11*$Q$7)),\"\")","v":""},null,{"$f":"IFERROR(IF(J$9=\"1\",VALUE(AVERAGE(L11,M11)),VALUE(MAX(L11,M11))),\"\")","v":""},null,null,{"$f":"IF(E11<>\"\",(IF(E11>0.74,\"A ordinario\",IF(E11>0.49,\"A extraordinario\",\"A recursar\"))),\"\")","v":""}]
[2,{"$f":"IF(Asistencia!B8<>\"\",Asistencia!B8,\"\")","v":""},{"$f":"IF(Asistencia!C8<>\"\",Asistencia!C8,\"\")","v":""},null,{"$f":"IF(D12<>\"\",(D12/$F$6),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B12<>\"\",COUNTBLANK(F12:K12)<6),((F12*$Q$2)+(G12*$Q$3)+(H12*$Q$4)+(I12*$Q$5)+(J12*$Q$6)+(K12*$Q$7)),\"\")","v":""},null,{"$f":"IFERROR(IF(J$9=\"1\",VALUE(AVERAGE(L12,M12)),VALUE(MAX(L12,M12))),\"\")","v":""},null,null,{"$f":"IF(E12<>\"\",(IF(E12>0.74,\"A ordinario\",IF(E12>0.49,\"A extraordinario\",\"A recursar\"))),\"\")","v":""}]
[3,{"$f":"IF(Asistencia!B9<>\"\",Asistencia!B9,\"\")","v":""},{"$f":"IF(Asistencia!C9<>\"\",Asistencia!C9,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[4,{"$f":"IF(Asistencia!B10<>\"\",Asistencia!B10,\"\")","v":""},{"$f":"IF(Asistencia!C10<>\"\",Asistencia!C10,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[5,{"$f":"IF(Asistencia!B11<>\"\",Asistencia!B11,\"\")","v":""},{"$f":"IF(Asistencia!C11<>\"\",Asistencia!C11,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[6,{"$f":"IF(Asistencia!B12<>\"\",Asistencia!B12,\"\")","v":""},{"$f":"IF(Asistencia!C12<>\"\",Asistencia!C12,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[7,{"$f":"IF(Asistencia!B13<>\"\",Asistencia!B13,\"\")","v":""},{"$f":"IF(Asistencia!C13<>\"\",Asistencia!C13,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[8,{"$f":"IF(Asistencia!B14<>\"\",Asistencia!B14,\"\")","v":""},{"$f":"IF(Asistencia!C14<>\"\",Asistencia!C14,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[9,{"$f":"IF(Asistencia!B15<>\"\",Asistencia!B15,\"\")","v":""},{"$f":"IF(Asistencia!C15<>\"\",Asistencia!C15,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[10,{"$f":"IF(Asistencia!B16<>\"\",Asistencia!B16,\"\")","v":""},{"$f":"IF(Asistencia!C16<>\"\",Asistencia!C16,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[11,{"$f":"IF(Asistencia!B17<>\"\",Asistencia!B17,\"\")","v":""},{"$f":"IF(Asistencia!C17<>\"\",Asistencia!C17,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[12,{"$f":"IF(Asistencia!B18<>\"\",Asistencia!B18,\"\")","v":""},{"$f":"IF(Asistencia!C18<>\"\",Asistencia!C18,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[13,{"$f":"IF(Asistencia!B19<>\"\",Asistencia!B19,\"\")","v":""},{"$f":"IF(Asistencia!C19<>\"\",Asistencia!C19,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[14,{"$f":"IF(Asistencia!B20<>\"\",Asistencia!B20,\"\")","v":""},{"$f":"IF(Asistencia!C20<>\"\",Asistencia!C20,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[15,{"$f":"IF(Asistencia!B21<>\"\",Asistencia!B21,\"\")","v":""},{"$f":"IF(Asistencia!C21<>\"\",Asistencia!C21,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[16,{"$f":"IF(Asistencia!B22<>\"\",Asistencia!B22,\"\")","v":""},{"$f":"IF(Asistencia!C22<>\"\",Asistencia!C22,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[17,{"$f":"IF(Asistencia!B23<>\"\",Asistencia!B23,\"\")","v":""},{"$f":"IF(Asistencia!C23<>\"\",Asistencia!C23,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[18,{"$f":"IF(Asistencia!B24<>\"\",Asistencia!B24,\"\")","v":""},{"$f":"IF(Asistencia!C24<>\"\",Asistencia!C24,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[19,{"$f":"IF(Asistencia!B25<>\"\",Asistencia!B25,\"\")","v":""},{"$f":"IF(Asistencia!C25<>\"\",Asistencia!C25,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[20,{"$f":"IF(Asistencia!B26<>\"\",Asistencia!B26,\"\")","v":""},{"$f":"IF(Asistencia!C26<>\"\",Asistencia!C26,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[21,{"$f":"IF(Asistencia!B27<>\"\",Asistencia!B27,\"\")","v":""},{"$f":"IF(Asistencia!C27<>\"\",Asistencia!C27,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[22,{"$f":"IF(Asistencia!B28<>\"\",Asistencia!B28,\"\")","v":""},{"$f":"IF(Asistencia!C28<>\"\",Asistencia!C28,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[23,{"$f":"IF(Asistencia!B29<>\"\",Asistencia!B29,\"\")","v":""},{"$f":"IF(Asistencia!C29<>\"\",Asistencia!C29,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[24,{"$f":"IF(Asistencia!B30<>\"\",Asistencia!B30,\"\")","v":""},{"$f":"IF(Asistencia!C30<>\"\",Asistencia!C30,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[25,{"$f":"IF(Asistencia!B31<>\"\",Asistencia!B31,\"\")","v":""},{"$f":"IF(Asistencia!C31<>\"\",Asistencia!C31,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[26,{"$f":"IF(Asistencia!B32<>\"\",Asistencia!B32,\"\")","v":""},{"$f":"IF(Asistencia!C32<>\"\",Asistencia!C32,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[27,{"$f":"IF(Asistencia!B33<>\"\",Asistencia!B33,\"\")","v":""},{"$f":"IF(Asistencia!C33<>\"\",Asistencia!C33,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[28,{"$f":"IF(Asistencia!B34<>\"\",Asistencia!B34,\"\")","v":""},{"$f":"IF(Asistencia!C34<>\"\",Asistencia!C34,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[29,{"$f":"IF(Asistencia!B35<>\"\",Asistencia!B35,\"\")","v":""},{"$f":"IF(Asistencia!C35<>\"\",Asistencia!C35,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[30,{"$f":"IF(Asistencia!B36<>\"\",Asistencia!B36,\"\")","v":""},{"$f":"IF(Asistencia!C36<>\"\",Asistencia!C36,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[31,{"$f":"IF(Asistencia!B37<>\"\",Asistencia!B37,\"\")","v":""},{"$f":"IF(Asistencia!C37<>\"\",Asistencia!C37,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[32,{"$f":"IF(Asistencia!B38<>\"\",Asistencia!B38,\"\")","v":""},{"$f":"IF(Asistencia!C38<>\"\",Asistencia!C38,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[33,{"$f":"IF(Asistencia!B39<>\"\",Asistencia!B39,\"\")","v":""},{"$f":"IF(Asistencia!C39<>\"\",Asistencia!C39,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[34,{"$f":"IF(Asistencia!B40<>\"\",Asistencia!B40,\"\")","v":""},{"$f":"IF(Asistencia!C40<>\"\",Asistencia!C40,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[35,{"$f":"IF(Asistencia!B41<>\"\",Asistencia!B41,\"\")","v":""},{"$f":"IF(Asistencia!C41<>\"\",Asistencia!C41,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[36,{"$f":"IF(Asistencia!B42<>\"\",Asistencia!B42,\"\")","v":""},{"$f":"IF(Asistencia!C42<>\"\",Asistencia!C42,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[37,{"$f":"IF(Asistencia!B43<>\"\",Asistencia!B43,\"\")","v":""},{"$f":"IF(Asistencia!C43<>\"\",Asistencia!C43,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[38,{"$f":"IF(Asistencia!B44<>\"\",Asistencia!B44,\"\")","v":""},{"$f":"IF(Asistencia!C44<>\"\",Asistencia!C44,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[39,{"$f":"IF(Asistencia!B45<>\"\",Asistencia!B45,\"\")","v":""},{"$f":"IF(Asistencia!C45<>\"\",Asistencia!C45,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[40,{"$f":"IF(Asistencia!B46<>\"\",Asistencia!B46,\"\")","v":""},{"$f":"IF(Asistencia!C46<>\"\",Asistencia!C46,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[41,{"$f":"IF(Asistencia!B47<>\"\",Asistencia!B47,\"\")","v":""},{"$f":"IF(Asistencia!C47<>\"\",Asistencia!C47,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[42,{"$f":"IF(Asistencia!B48<>\"\",Asistencia!B48,\"\")","v":""},{"$f":"IF(Asistencia!C48<>\"\",Asistencia!C48,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[43,{"$f":"IF(Asistencia!B49<>\"\",Asistencia!B49,\"\")","v":""},{"$f":"IF(Asistencia!C49<>\"\",Asistencia!C49,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[44,{"$f":"IF(Asistencia!B50<>\"\",Asistencia!B50,\"\")","v":""},{"$f":"IF(Asistencia!C50<>\"\",Asistencia!C50,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[45,{"$f":"IF(Asistencia!B51<>\"\",Asistencia!B51,\"\")","v":""},{"$f":"IF(Asistencia!C51<>\"\",Asistencia!C51,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[46,{"$f":"IF(Asistencia!B52<>\"\",Asistencia!B52,\"\")","v":""},{"$f":"IF(Asistencia!C52<>\"\",Asistencia!C52,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[47,{"$f":"IF(Asistencia!B53<>\"\",Asistencia!B53,\"\")","v":""},{"$f":"IF(Asistencia!C53<>\"\",Asistencia!C53,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[48,{"$f":"IF(Asistencia!B54<>\"\",Asistencia!B54,\"\")","v":""},{"$f":"IF(Asistencia!C54<>\"\",Asistencia!C54,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[49,{"$f":"IF(Asistencia!B55<>\"\",Asistencia!B55,\"\")","v":""},{"$f":"IF(Asistencia!C55<>\"\",Asistencia!C55,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[50,{"$f":"IF(Asistencia!B56<>\"\",Asistencia!B56,\"\")","v":""},{"$f":"IF(Asistencia!C56<>\"\",Asistencia!C56,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[51,{"$f":"IF(Asistencia!B57<>\"\",Asistencia!B57,\"\")","v":""},{"$f":"IF(Asistencia!C57<>\"\",Asistencia!C57,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[52,{"$f":"IF(Asistencia!B58<>\"\",Asistencia!B58,\"\")","v":""},{"$f":"IF(Asistencia!C58<>\"\",Asistencia!C58,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[53,{"$f":"IF(Asistencia!B59<>\"\",Asistencia!B59,\"\")","v":""},{"$f":"IF(Asistencia!C59<>\"\",Asistencia!C59,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[54,{"$f":"IF(Asistencia!B60<>\"\",Asistencia!B60,\"\")","v":""},{"$f":"IF(Asistencia!C60<>\"\",Asistencia!C60,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[55,{"$f":"IF(Asistencia!B61<>\"\",Asistencia!B61,\"\")","v":""},{"$f":"IF(Asistencia!C61<>\"\",Asistencia!C61,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[56,{"$f":"IF(Asistencia!B62<>\"\",Asistencia!B62,\"\")","v":""},{"$f":"IF(Asistencia!C62<>\"\",Asistencia!C62,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[57,{"$f":"IF(Asistencia!B63<>\"\",Asistencia!B63,\"\")","v":""},{"$f":"IF(Asistencia!C63<>\"\",Asistencia!C63,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[58,{"$f":"IF(Asistencia!B64<>\"\",Asistencia!B64,\"\")","v":""},{"$f":"IF(Asistencia!C64<>\"\",Asistencia!C64,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[59,{"$f":"IF(Asistencia!B65<>\"\",Asistencia!B65,\"\")","v":""},{"$f":"IF(Asistencia!C65<>\"\",Asistencia!C65,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[60,{"$f":"IF(Asistencia!B66<>\"\",Asistencia!B66,\"\")","v":""},{"$f":"IF(Asistencia!C66<>\"\",Asistencia!C66,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[61,{"$f":"IF(Asistencia!B67<>\"\",Asistencia!B67,\"\")","v":""},{"$f":"IF(Asistencia!C67<>\"\",Asistencia!C67,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[62,{"$f":"IF(Asistencia!B68<>\"\",Asistencia!B68,\"\")","v":""},{"$f":"IF(Asistencia!C68<>\"\",Asistencia!C68,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[63,{"$f":"IF(Asistencia!B69<>\"\",Asistencia!B69,\"\")","v":""},{"$f":"IF(Asistencia!C69<>\"\",Asistencia!C69,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[64,{"$f":"IF(Asistencia!B70<>\"\",Asistencia!B70,\"\")","v":""},{"$f":"IF(Asistencia!C70<>\"\",Asistencia!C70,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[65,{"$f":"IF(Asistencia!B71<>\"\",Asistencia!B71,\"\")","v":""},{"$f":"IF(Asistencia!C71<>\"\",Asistencia!C71,\"\")","v":""},null,"",null,null,null,null,null,null,"",null,"",null,null,""]
[66,{"$f":"IF(Asistencia!B72<>\"\",Asistencia!B72,\"\")","v":""},{"$f":"IF(Asistencia!C72<>\"\",Asistencia!C72,\"\")","v":""},null,{"$f":"IF(D76<>\"\",(D76/$F$6),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B76<>\"\",COUNTBLANK(F76:K76)<6),((F76*$Q$2)+(G76*$Q$3)+(H76*$Q$4)+(I76*$Q$5)+(J76*$Q$6)+(K76*$Q$7)),\"\")","v":""},null,{"$f":"IFERROR(IF(J$9=\"1\",VALUE(AVERAGE(L76,M76)),VALUE(MAX(L76,M76))),\"\")","v":""},null,null,{"$f":"IF(E76<>\"\",(IF(E76>0.74,\"A ordinario\",IF(E76>0.49,\"A extraordinario\",\"A recursar\"))),\"\")","v":""}]
[67,{"$f":"IF(Asistencia!B73<>\"\",Asistencia!B73,\"\")","v":""},{"$f":"IF(Asistencia!C73<>\"\",Asistencia!C73,\"\")","v":""},null,{"$f":"IF(D77<>\"\",(D77/$F$6),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B77<>\"\",COUNTBLANK(F77:K77)<6),((F77*$Q$2)+(G77*$Q$3)+(H77*$Q$4)+(I77*$Q$5)+(J77*$Q$6)+(K77*$Q$7)),\"\")","v":""},null,"",null,null,{"$f":"IF(E77<>\"\",(IF(E77>0.74,\"A ordinario\",IF(E77>0.49,\"A extraordinario\",\"A recursar\"))),\"\")","v":""}]
[68,{"$f":"IF(Asistencia!B74<>\"\",Asistencia!B74,\"\")","v":""},{"$f":"IF(Asistencia!C74<>\"\",Asistencia!C74,\"\")","v":""},null,{"$f":"IF(D78<>\"\",(D78/$F$6),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B78<>\"\",COUNTBLANK(F78:K78)<6),((F78*$Q$2)+(G78*$Q$3)+(H78*$Q$4)+(I78*$Q$5)+(J78*$Q$6)+(K78*$Q$7)),\"\")","v":""},null,"",null,null,{"$f":"IF(E78<>\"\",(IF(E78>0.74,\"A ordinario\",IF(E78>0.49,\"A extraordinario\",\"A recursar\"))),\"\")","v":""}]
[]
["a"]

{"sheet":"Reporte","index":3,"n_rows":38,"n_cols":34,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,29],[38,0,38,29],[32,18,32,20],[31,18,31,20],[30,18,30,20],[34,15,34,17],[35,15,35,17],[35,18,35,20],[34,18,34,20],[33,18,33,20],[33,15,33,17],[33,0,33,14],[34,0,34,14],[35,0,35,14],[29,18,29,20],[29,0,29,14],[30,0,30,14],[31,0,31,14],[32,0,32,14],[29,15,29,17],[30,15,30,17],[31,15,31,17],[32,15,32,17],[28,0,28,29],[17,22,17,29],[1,3,2,15],[9,0,9,29],[5,16,5,18],[5,19,5,29],[2,19,2,29],[7,2,7,15],[27,0,27,29],[25,15,25,29],[15,0,15,14],[16,0,16,14],[17,0,17,14],[20,15,20,29],[21,15,21,29],[25,1,25,9],[0,16,0,18],[2,16,2,18],[15,15,15,21],[17,15,17,21],[0,19,0,29],[10,15,10,29],[11,15,11,29],[12,15,12,29],[13,15,13,29],[14,15,14,21],[14,22,14,29],[3,16,3,18],[4,16,4,18],[3,19,3,29],[4,19,4,29],[1,16,1,18],[1,19,1,29],[16,15,16,21],[15,22,15,29],[16,22,16,29],[10,0,10,14],[11,0,11,14],[12,0,12,14],[13,0,13,14],[14,0,14,14],[3,0,5,15],[6,0,6,15],[25,10,25,11],[19,0,19,11],[19,12,19,29],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,1,23,9],[24,1,24,9],[23,10,23,11],[24,10,24,11],[22,15,22,29],[23,15,23,29],[24,15,24,29],[20,1,20,9],[21,1,21,9],[22,1,22,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Profesor",null,null,{"$f":"IF(Datos!C3<>\"\",(CONCATENATE(Datos!C3,\" \",Datos!C4)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Academia",null,null,{"$f":"IFERROR(Datos!C6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asignatura",null,null,{"$f":"IF(Datos!C2<>\"\",Datos!C2,\"\")","v":""}]
[{"$f":"CONCATENATE(T3,\" \",T5)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semestre",null,null,{"$f":"IF(Datos!H3<>\"\",Datos!H3,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sección",null,null,{"$f":"IF(Datos!H2<>\"\",Datos!H2,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciclo",null,null,{"$f":"IF(Datos!H4<>\"\",Datos!H4,\"\")","v":""}]
["Reporte de Unidad de Aprendizaje"]
[null,null,{"$f":"CONCATENATE(\"\\\",Datos!C7,\"_CUALI.pdf\")","v":"\\_CUALI.pdf"}]
[]
["Indicadores de desempeño del curso"]
["Asistentes al curso",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Asistencia!V4","v":0}]
["Porcentaje de cumplimiento del programa"]
["Procentaje de asistencia global",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!F6>0,(SUM(Calificaciones!E11:E78)/P11),\"\")","v":""}]
["Promedio general en ordinario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!N11<>\"\",(AVERAGEIF(Calificaciones!N11:N78,\">0.1\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN","MAX","COUNT","CLASE"]
["Alumnos aprobados en ordinario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!N11<>\"\",(COUNTIF(Calificaciones!N11:N78,\">5.9\")),0)","v":0},null,null,null,null,null,null,{"$f":"IF(P15<>\"\",(P15/P11),\"\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"0",1,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">0\",Calificaciones!N$11:N$78,\"<1\")","v":0},"0-1"]
["Alumnos que aprueban en extra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Calificaciones!O11:O78,\">5.9\")","v":0},null,null,null,null,null,null,{"$f":"IF(P$11>0,(P16/P$11),\"\")","v":""},null,null,null,null,null,null,null,"1",2,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">.9\",Calificaciones!N$11:N$78,\"<2\")","v":0},"1-2"]
["Alumnos que aprueban en regularización",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Calificaciones!P11:P78,\">5.9\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,null,null,"2",3,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">1.9\",Calificaciones!N$11:N$78,\"<3\")","v":0},"2-3"]
["Alumnos que tienen que recursar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P11>0,(0+(P11-P15-P16-P17)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(P$11>0,(P18/P$11),\"\")","v":""},null,null,null,null,null,null,null,"3",4,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">2.9\",Calificaciones!N$11:N$78,\"<4\")","v":0},"3-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4",5,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">3.9\",Calificaciones!N$11:N$78,\"<5\")","v":0},"4-5"]
["Criterios de evaluación",null,null,null,null,null,null,null,null,null,null,null,"Distribución de calificaciones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5",6,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">4.9\",Calificaciones!N$11:N$78,\"<6\")","v":0},"5-6"]
[1,{"$f":"IF(Calificaciones!I2<>\"\",Calificaciones!I2,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!Q2<>\"\",Calificaciones!Q2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6",7,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">5.9\",Calificaciones!N$11:N$78,\"<7\")","v":0},"6-7"]
[2,{"$f":"IF(Calificaciones!I3<>\"\",Calificaciones!I3,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!Q3<>\"\",Calificaciones!Q3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7",8,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">6.9\",Calificaciones!N$11:N$78,\"<8\")","v":0},"7-8"]
[3,{"$f":"IF(Calificaciones!I4<>\"\",Calificaciones!I4,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!Q4<>\"\",Calificaciones!Q4,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8",9,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">7.9\",Calificaciones!N$11:N$78,\"<9\")","v":0},"8-9"]
[4,{"$f":"IF(Calificaciones!I5<>\"\",Calificaciones!I5,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!Q5<>\"\",Calificaciones!Q5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9",10,{"$f":"COUNTIFS(Calificaciones!N$11:N$78,\">8.9\",Calificaciones!N$11:N$78,\"<10.1\")","v":0},"9-10"]
[5,{"$f":"IF(Calificaciones!I6<>\"\",Calificaciones!I6,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!Q6<>\"\",Calificaciones!Q6,\"\")","v":""}]
[6,{"$f":"IF(Calificaciones!I7<>\"\",Calificaciones!I7,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Calificaciones!Q7<>\"\",Calificaciones!Q7,\"\")","v":""}]
[]
["Uso de recursos didácticos"]
[{"$f":"CONCATENATE(\"De las \",Calificaciones!F6,\" clases impartidas en este ciclo, ¿en cuántas (aproximadamente) utilizó los recursos abajo enlistados?\")","v":"De las  clases impartidas en este ciclo, ¿en cuántas (aproximadamente) utilizó los recursos abajo enlistados?"}]
["Centro de cómputo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(P30/Calificaciones!$F$6,\"--\")","v":"--"}]
["Cámara de Gesell",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(P31/Calificaciones!$F$6,\"--\")","v":"--"}]
["Computadora portatil y proyector",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(P32/Calificaciones!$F$6,\"--\")","v":"--"}]
["Bocinas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(P33/Calificaciones!$F$6,\"--\")","v":"--"}]
["Visitas guiadas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(P34/Calificaciones!$F$6,\"--\")","v":"--"}]
["Prácticas al exterior para obtener datos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(P35/Calificaciones!$F$6,\"--\")","v":"--"}]
["Prácticas al exterior para intervención",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(P36/Calificaciones!$F$6,\"--\")","v":"--"}]
[]
["Evaluación cualitativa"]